﻿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!--DXMETADATA start type="MetaCharset" --><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><!--DXMETADATA end-->
    <meta http-equiv="X-UA-Compatible" value="IE=9" />

    <!--DXMETADATA start type="Literal" condition="helpversion:value=3" value="<meta name=""Microsoft.Help.SelfBranded"" content=""true"" />" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<title>%%ProjectTitle%% - %%ItemTitle%%</title>" --><title>SpreadJS Documentation - Formula Text Box</title><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<meta name=""Title"" content=""%%ProjectTitle%% - %%ItemTitleNoQuotes%%""/>" --><meta name="Title" content="SpreadJS Documentation - Formula Text Box"/><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="jquery" filetype="script" firstlinkattributes="id=""mshs_support_script"""--><script src="template/packages/jquery/script/default/jquery-1.11.3.min.js" type="text/javascript" id="mshs_support_script"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="script"--><script src="template/packages/jquery-ui/script/default/jquery-ui-1.11.4.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/jquery-ui/css/default/jquery-ui-1.11.4.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="TemplateSettingsJson" format="<script type=""text/javascript"">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:%%TemplateSettingsJson%%});</script>" --><script type="text/javascript">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:{"dynamictoc":{"initialNodeId":"n172","initialNodeContainer":"c0","isResizable":true},"inthistopic":{"isEnabled":true},"currentLocale":"-","isFrameless":true,"navigationKind":"inpage","versions":{"locale":{"currentId":"-"}}}});</script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="light" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/light/css/dynamic-toc.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="Synopsis" StripHtmlTags="True" MaxLength="250" format="<meta name=""Description"" content=""%%Synopsis%%"" />"--><meta name="Description" content="A formula text box is displayed when editing or creating formulas at run time. The formula text box displays built-in formulas, table names, column names in tables, and custom names." /><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/plugins-topics/css/default/jquery-plugins.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="css" firstlinkattributes=" data-mshv2-stylesheet=""/template/packages/core-topics/topics.mshv2.css"" data-mshv1-stylesheet=""/template/packages/core-topics/topics.mshv1.css"" data-responsive-mobile=""template/packages/core-topics/topics.mobile.css"" data-responsive-tablet=""template/packages/core-topics/topics.tablet.css"""--><link rel="stylesheet" type="text/css" href="template/packages/core-topics/css/topics.css"  data-mshv2-stylesheet="/template/packages/core-topics/topics.mshv2.css" data-mshv1-stylesheet="/template/packages/core-topics/topics.mshv1.css" data-responsive-mobile="template/packages/core-topics/topics.mobile.css" data-responsive-tablet="template/packages/core-topics/topics.tablet.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="script"--><script src="template/packages/plugins-topics/script/default/jquery-plugins.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="script"--><script src="template/packages/core-topics/script/topics.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="TopicId" format="<meta name=""Microsoft.Help.Id"" content=""%%TopicId%%""/>" --><meta name="Microsoft.Help.Id" content="6f94f267-fcca-42f6-8a71-b7a67bc51adc"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocParentId" format="<meta name=""Microsoft.Help.TocParent"" content=""%%TocParentId%%""/>" --><meta name="Microsoft.Help.TocParent" content="20ec19b6-d22d-41ba-a05b-c2910bd90ae6"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocOrdinal" format="<meta name=""Microsoft.Help.TocOrder"" content=""%%TocOrdinal%%""/>" --><meta name="Microsoft.Help.TocOrder" content="5"/><!--DXMETADATA end-->
    <meta name="Microsoft.Help.F1" content=""/>
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <!--DXMETADATA start type="MshvKeywords" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="MshvMetaTags" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.Locale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.TopicLocale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Stylesheets" --><link rel="stylesheet" type="text/css" href="stylesheets/hs-simpletab.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="StylePropertyValues" format="<style>%%StylePropertyValues%%</style>" --><style>.i-is-new .i-page-title-text::after, ul#i-dt-root li.i-is-new>a::after { content: "New" }
</style><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scripts" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="DesignTime"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end -->
    <!--DXMETADATA start type="CustomHeadContent" --><link rel="stylesheet" type="text/css" href="template/packages/core-web/css/SP.css">
<script type="text/javascript">
var currentHeader = function() {
    return "spjs";
}
</script>
<script src="template/packages/core-web/script/topNavigation.js"></script>
<script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-WT462SJ"></script>
<script>
        (function (w, d, s, l, i) {
            w[l] = w[l] || [];
            w[l].push({
                'gtm.start': new Date().getTime()
                , event: 'gtm.js'
            });
            var f = d.getElementsByTagName(s)[0]
                , j = d.createElement(s)
                , dl = l != 'dataLayer' ? '&l=' + l : '';
            j.async = true;
            j.src = 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
            f.parentNode.insertBefore(j, f);
        })(window, document, 'script', 'dataLayer', 'GTM-WT462SJ');
    </script>
<!--DXMETADATA end-->
</head>

<body>
    <div id="i-before-header-content" class="i-before-header-content">
        
    </div>

    <div id="i-header-container">
        <div id="i-header-content" class="i-header-content i-content-width-container">
            <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end-->
            <div class="i-project-title"><!--DXMETADATA start type="ProjectTitle" -->SpreadJS Documentation<!--DXMETADATA end--></div>
            <div class="i-search-container">
                <!--DXMETADATA start type="outputfileextension" format="<form action=""websearch%%outputfileextension%%"">" --><form action="websearch.html"><!--DXMETADATA end-->
                <input id="i-search" name="query"/>
                <input type="submit" id="i-search-button" value=""/>
                <!--DXMETADATA start type="Literal" value="</form>" --></form><!--DXMETADATA end-->
            </div>
            <!--DXMETADATA start type="outputfileextension" format="<a id=""i-index-button"" href=""webindex%%outputfileextension%%""></a>" --><a id="i-index-button" href="webindex.html"></a><!--DXMETADATA end-->
        </div>
    </div>
    
    <div class="i-content-width-container"><div class="i-busy-overlay"></div></div>

    <div id="i-breadcrumbs-outer-container" class="i-content-width-container"><!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="i-breadcrumbs-container">
<a href="overview.html">SpreadJS Documentation</a>
 / <a href="devguide.html">Developer's Guide</a>
 / <a href="features.html">Features</a>
 / <a href="interface.html">Manage User Interface</a>
 / <a href="formulas.html">Formulas</a>
 / Formula Text Box</div><!--DXMETADATA end --></div>

    

    <div id="i-actions-outer-container" class="i-content-width-container">
        <div id="i-actions-container">
            <div id="i-actions-content" class="i-fixed-to-top">
                <!-- Spacing --> <span class="i-toggle-all-sections i-function-link">
                <label class="i-collapse-all"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label>
                <label class="i-expand-all" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label>
            </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end -->
                <div class="i-in-this-topic-container">
                    <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
                </div>
            </div>
        </div>
    </div>

    <div id="i-toc-outer-container" class="i-content-width-container">
        <div id="i-toc-container">
            <div id="i-toc-content" class="i-fixed-to-top">
                <div class="i-toc-content-scroll-container">
                    <div id="i-dynamic-toc-container"><ul id="i-dt-root"></ul></div>
                </div>
            </div>
        </div>
    </div>

    <div id="i-body-content-container" class="i-content-width-container">
        <div id="i-body-content" class="i-body-content">
            <div class="i-page-title"><div class="i-page-title-text"><!--DXMETADATA start type="ItemTitle" -->Formula Text Box<!--DXMETADATA end--></div></div>
            <div class="i-in-this-topic-container">
                <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
            </div>
            <!--DXMETADATA start type="TopicSection" name="BodyText"--><p>A formula text box is displayed when editing or creating formulas at run time. The formula text box displays built-in formulas, table names, column names in tables, and custom names.</p>

<p>You can use the formula text box to change the cell or cell ranges referenced by the formula. You can also use the formula text box to add formulas from another sheet.</p>

<p>A border is displayed when using the mouse to select a cell range for a formula. Place the pointer at any of the four corners of the formula text box and the pointer changes to a double arrow. Click and drag to expand the selected cell range. For example, type "=SUM(C1" in a cell and then use the mouse to select a cell range.</p>

<p><img border="0" alt="" src="images/formulabox1.png" /></p>

<p>A different border color is used for a second cell or range.</p>

<p><img border="0" alt="" src="images/formulabox3.png" /></p>

<p>Similarly, a different border color is used for the third cell or range and so on.</p>

<p>In a large formula where multiple cells are used or a cell range (that spans to two or more cells) is selected, the in-cell formula textbox displays colorful text as shown in the below image:</p>

<p><img border="0" alt="" src="images/formula_textbox_new.png" /></p>

<p>The structured reference range for a table or a custom name range is highlighted after typing the text in the formula text box.</p>

<p><img border="0" alt="" src="images/formulaboxtable.png" /></p>

<p>A list of formula names is displayed when typing a name. Press the Tab key to select the highlighted name.</p>

<p><img border="0" alt="" src="images/formulabox.png" /></p>

<p>You can also use the formula text box to select a different cell or cell range. Place the pointer on the border of the formula text box and use the cross shape pointer to click and drag the formula text box to a new location.</p>

<p><img border="0" alt="" src="images/formulabox2.png" /></p>

<p>Use the following instructions to add a formula on Sheet1 that references Sheet2:</p>

<ol>
    <li>Add the formula on Sheet1.

        <p><img border="0" alt="" src="images/formulaboxsheet.png" /></p>
    </li>

    <li>Select the Sheet2 tab.</li>

    <li>Select the cell or range.

        <p><img border="0" alt="" src="images/formulaboxsheet1.png" /></p>
    </li>

    <li>Type any additional formula characters.</li>

    <li>Press Enter.

        <p><img border="0" alt="" src="images/formulaboxsheet2.png" /></p>
    </li>
</ol>

<p>You can use the following shortcut keys to change the cell or cell range selection while entering formulas.</p>

<table>
    <tbody>
        <tr>
            <td><strong>Shortcut Key</strong></td>

            <td><strong>Action</strong></td>
        </tr>

        <tr>
            <td>Shift+Left</td>

            <td>SelectionLeft</td>
        </tr>

        <tr>
            <td>Shift+Right</td>

            <td>SelectionRight</td>
        </tr>

        <tr>
            <td>Shift+Up</td>

            <td>SelectionUp</td>
        </tr>

        <tr>
            <td>Shift+Down</td>

            <td>SelectionDown</td>
        </tr>

        <tr>
            <td>Shift+Home</td>

            <td>SelectionHome</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+Left</td>

            <td>SelectionHome</td>
        </tr>

        <tr>
            <td>Shift+End</td>

            <td>SelectionEnd</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+Right</td>

            <td>SelectionEnd</td>
        </tr>

        <tr>
            <td>Shift+PageUp</td>

            <td>SelectionPageUp</td>
        </tr>

        <tr>
            <td>Shift+PageDown</td>

            <td>SelectionPageDown</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+Up</td>

            <td>SelectionTop</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+Down</td>

            <td>SelectionBottom</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+Home</td>

            <td>SelectionFirst</td>
        </tr>

        <tr>
            <td>Ctrl+Shift+End</td>

            <td>SelectionLast</td>
        </tr>

        <tr>
            <td>Ctrl + Down</td>

            <td>NavigationBottom</td>
        </tr>

        <tr>
            <td>Down</td>

            <td>NavigationDown</td>
        </tr>

        <tr>
            <td>End</td>

            <td>NavigationEnd</td>
        </tr>

        <tr>
            <td>Ctrl+Right</td>

            <td>NavigationEnd</td>
        </tr>

        <tr>
            <td>Ctrl+Home</td>

            <td>NavigationFirst</td>
        </tr>

        <tr>
            <td>Home</td>

            <td>NavigationHome</td>
        </tr>

        <tr>
            <td>Ctrl+Left</td>

            <td>NavigationHome</td>
        </tr>

        <tr>
            <td>Ctrl+End</td>

            <td>NavigationLast</td>
        </tr>

        <tr>
            <td>Left</td>

            <td>NavigationLeft</td>
        </tr>

        <tr>
            <td>PageDown</td>

            <td>NavigationPageDown</td>
        </tr>

        <tr>
            <td>Ctrl+PageUp</td>

            <td>NavigationPreviousSheet</td>
        </tr>

        <tr>
            <td>Ctrl+PageDown</td>

            <td>NavigationNextSheet</td>
        </tr>

        <tr>
            <td>PageUp</td>

            <td>NavigationPageUp</td>
        </tr>

        <tr>
            <td>Right</td>

            <td>NavigationRight</td>
        </tr>

        <tr>
            <td>Ctrl+Up</td>

            <td>NavigationTop</td>
        </tr>

        <tr>
            <td>Up</td>

            <td>NavigationUp</td>
        </tr>
    </tbody>
</table><!--DXMETADATA end-->
            <a name="seealsobookmark"></a>
            <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><div class="i-section-heading" id="i-seealso-section-heading"><span class="i-section-heading-icon"><!-- --></span><span class="i-section-heading-text">See Also</span></div><div id="i-seealso-section-content" class="i-section-content"><div class="i-see-also-link">
<a href="formulauser.html">Allow Users to Enter Formulas</a></div>
<div class="i-see-also-link">
<a href="formulaname.html">Create Custom Names</a></div>
<div class="i-see-also-link">
<a href="tables.html">Create Tables</a></div>
<div class="i-see-also-link">
<a href="structref.html">Structured Reference Formulas</a></div>
<div class="i-see-also-link">
<a href="SpreadJS~GC.Spread.Sheets.FormulaTextBox.FormulaTextBox.html">FormulaTextBox class</a></div>

</div><!--DXMETADATA end-->
            
            <div id="i-footer-content" class="i-footer-content">
                <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p>&nbsp;</p><p>&nbsp;</p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p>&nbsp;</p><p>&nbsp;</p><hr style="height: 1px" /><p><p>Copyright © 2019 GrapeCity, Inc. All rights reserved.</p>
<p><a href="https://www.grapecity.com/en/forums/winforms-edition" target="_blank">Product Support Forum</a> | <a href="javascript:window.print()">Print this page</a></p>
<ul class="social">
<li><a href="https://www.facebook.com/GrapeCityUS/" target="_blank" class="facebook">&nbsp;</a></li>
<li><a href="https://twitter.com/GrapeCityUS" target="_blank" class="twitter">&nbsp;</a></li>
<li><a href="https://www.linkedin.com/company/grapecity" target="_blank" class="linkedin">&nbsp;</a></li>
</ul>
</p><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end-->
            </div>
        </div>
    </div>
        
    <script type="text/javascript">
        $(function () {
            var documentInstance = new Innovasys.Content.Document(document.body);
            documentInstance.load();
        });
    </script>
</body>
</html>
